ÍÍÍÍÍÍ Before You Begin ÍÍÍÍÍÍ
General
  (c) Microsoft Corporation
General wn 26
  Using Help
General wn
  Doc Changes Since Printing
General nx 26
  What's New Since FoxPro 2.5
General wn nx 26
  Product Support
General er 26
  CompuServe -- The Fox Forum
  Switching From dBASE
General 26
ÍÍÍÍÍÍÍ General Topics ÍÍÍÍÍÍÍ
  Color Table by Color Pair
General en in
  Colors
  Command Continuation
General wi
  Commonly Used Commands
General nx
  Compatibility
General cm 26
  Configuring FoxPro
General cf en 26
  DOS and Windows Differences
  Error Messages
General em
  File Extensions
General fm 26
  Fonts
General in
  FoxApp - Build Applications
General pe 26
  FoxPro Reserved Words
  Generator Directives
  How FoxPro Finds Components
General cf
  International Settings
  International/X-Platform
  Name Expressions
General fm pe
  Report Tips
General pr
  Rushmore Technology
  Sample Files
  SQL Cursors
General sq db
  System Capacities
General cf 26
  Tips and Tricks
  Transporting Files
General cm nx 26
  Version Control & Projects
General pe
ÍÍÍÍÍÍ Troubleshooting ÍÍÍÍÍÍÍ
  How to Troubleshoot
  How to Perform a Clean Boot
  Installation and Setup Errs
  Network Error Messages
  Printing Error Messages
  Internal Consistency Errs
  Insufficient Memory
  Connectivity Kit Error Msgs
  General Protection Faults
  Top 25 Common Issues
  Top 20 Coding Errors
ÍÍÍÍÍ The FoxPro Language ÍÍÍÍ
%
Function nu
&
Function ch
$
=
Command mv
\ | \\
Command tm
? | ??
Command pr in ex
???
Command pr
@ ... SAY
@ ... SAY - BMPs & OLE Objects
Command pr in nx
@ ... GET
Controls
Command in
@ ... GET - Check Boxes
Command in ex
@ ... GET - Invisible Buttons
@ ... GET - Lists
@ ... GET - Popups
@ ... GET - Push Buttons
@ ... GET - Radio Buttons
@ ... GET - Spinners
Command in nx
@ ... EDIT - Text Edit Regions
@ ... BOX
@ ... CLEAR
@ ... FILL
@ ... MENU
Command mp
@ ... PROMPT
@ ... TO
ABS()
ACCEPT
Command mv in
ACOPY()
Function mv
ACOS()
ACTIVATE MENU
ACTIVATE POPUP
ACTIVATE SCREEN
Command in wi
ACTIVATE WINDOW
Command wi
ADEL()
ADIR()
AELEMENT()
AFIELDS()
AFONT()
Function en in nx
AINS()
ALEN()
ALIAS()
Function db
ALLTRIM()
ANSITOOEM()
Function ch nx
APPEND
Command db in
APPEND FROM
Command db ex
APPEND FROM ARRAY
APPEND GENERAL
Command db nx
APPEND MEMO
Command db
ASC()
ASCAN()
ASIN()
ASORT()
ASUBSCRIPT()
AT()
ATAN()
ATC()
ATCLINE()
ATLINE()
ATN2()
AVERAGE
Command mv db
BAR()
Function mp
BETWEEN()
Function ch nu dt
BLANK
Command 26
BOF()
Function lo db
BROWSE
Command db in ex
BUILD APP
Command pe
BUILD EXE
BUILD PROJECT
CALCULATE
CALL
CANCEL
CAPSLOCK()
Function en km
CDOW()
Function dt
CDX()
Function db ix
CEILING()
CHANGE
CHR()
Function ch dc
CHRSAW()
Function km
CHRTRAN()
CLEAR
Command mv mp wi in
CLOSE
Command db fm
CLOSE MEMO
CMONTH()
CNTBAR()
Function mp 26
CNTPAD()
COL()
Function en in
COMPILE
CONTINUE
COPY FILE
Command fm
COPY INDEXES
Command db ix
COPY MEMO
COPY STRUCTURE
COPY STRUCTURE EXTENDED
COPY TAG
COPY TO
COPY TO ARRAY
COS()
COUNT
CPCONVERT()
Function db nx
CPCURRENT()
CPDBF()
CREATE
CREATE COLOR SET
Command en in
CREATE CURSOR - SQL
CREATE FROM
CREATE LABEL
CREATE MENU
CREATE PROJECT
CREATE QUERY
Command db sq
CREATE REPORT
CREATE REPORT - Quick Report
CREATE SCREEN
CREATE SCREEN - Quick Screen
CREATE TABLE - SQL
Command sq db
CREATE VIEW
Command en fm
CTOD()
Function ch dt dc
CURDIR()
Function fm
DATE()
DAY()
DBF()
DDE Functions
Function pe nx
DDEAbortTrans()
DDEAdvise()
DDEEnabled()
DDEExecute()
DDEInitiate()
DDELastError()
DDEPoke()
DDERequest()
DDESetOption()
DDESetService()
DDESetTopic()
DDETerminate()
DEACTIVATE MENU
DEACTIVATE POPUP
DEACTIVATE WINDOW
DECLARE
#DEFINE ... #UNDEF
Command pe sp nx
DEFINE BAR
Command mp ex
DEFINE BOX
DEFINE MENU
DEFINE PAD
DEFINE POPUP
DEFINE WINDOW
Command wi ex
DELETE
DELETE FILE
DELETE TAG
DELETED()
DESCENDING()
Function 26 lo
DIFFERENCE()
DIMENSION
DIRECTORY
Command en fm ex
DISKSPACE()
DISPLAY
Command mv en pr
DISPLAY FILES
DISPLAY MEMORY
Command mv en
DISPLAY STATUS
Command en
DISPLAY STRUCTURE
DMY()
DO
Command fm pe
DO CASE
Command sp
DO WHILE
DOW()
DTOC()
Function ch dt
DTOR()
DTOS()
EDIT
EJECT
EJECT PAGE
EMPTY()
EOF()
ERASE
ERROR()
Function en
EVALUATE()
Function ch nu dt lo
EXIT
EXP()
EXPORT
EXTERNAL
FCHSIZE()
Function ll
FCLOSE()
FCOUNT()
FCREATE()
FEOF()
FERROR()
FFLUSH()
FGETS()
FIELD()
FILE()
Function lo fm
FILER
FILTER()
FIND
FKLABEL()
FKMAX()
FLOCK()
Function mu
FLOOR()
FLUSH
FONTMETRIC()
Function in nx
FOPEN()
FOR()
Function 26 ch
FOR ... ENDFOR
FOUND()
FPUTS()
FREAD()
FSEEK()
FSIZE()
FULLPATH()
FUNCTION
FV()
FWRITE()
GATHER
Command db mv
GETBAR()
GETDIR()
GETENV()
GETEXPR
GETFILE()
Function en fm
GETFONT()
GETPAD()
GO/GOTO
GOMONTH()
HEADER()
HELP
HIDE MENU
HIDE POPUP
HIDE WINDOW
HOME()
IDXCOLLATE()
Function ix nx
#IF ... #ENDIF
IF ... ENDIF
IIF()
IMPORT
Command db fm ex
INDEX
INKEY()
Function en km in
INLIST()
INPUT
INSERT
INSERT - SQL
INSMODE()
INT()
ISALPHA()
Function ch lo
ISBLANK()
ISCOLOR()
Function lo en
ISDIGIT()
ISLOWER()
ISREADONLY()
Function 26
ISUPPER()
JOIN
KEY()
KEYBOARD
Command km
KEYMATCH()
LABEL
Command pr ex
LASTKEY()
LEFT()
LEN()
LIKE()
LINENO()
LIST
Command mv fm pr
LOAD
LOCATE
LOCFILE()
LOCK()
LOG()
LOG10()
LOOKUP()
LOWER()
LTRIM()
LUPDATE()
MAX()
MCOL()
MDOWN()
MDX()
MDY()
MEMLINES()
MEMORY()
MENU
MENU - System Menu Names
MENU TO
MENU()
MESSAGE()
MIN()
MLINE()
MOD()
MODIFY COMMAND/FILE
Command fm ex
MODIFY GENERAL
MODIFY LABEL
MODIFY MEMO
MODIFY MENU
MODIFY PROJECT
MODIFY QUERY
MODIFY REPORT
MODIFY SCREEN
MODIFY STRUCTURE
MODIFY WINDOW
Command wi nx
MONTH()
MOVE POPUP
MOVE WINDOW
MRKBAR()
MRKPAD()
MROW()
MWINDOW()
Function km wi
NDX()
NORMALIZE()
NOTE | * | &&
Command er
NUMLOCK()
OBJNUM()
Function in
OBJVAR()
OCCURS()
OEMTOANSI()
ON BAR
Command eh mp
ON ERROR
Command eh er mu
ON ESCAPE
Command eh
ON KEY
Command eh km
ON KEY =
ON KEY LABEL
ON PAD
ON PAGE
ON READERROR
Command eh er
ON SELECTION BAR
ON SELECTION MENU
ON SELECTION PAD
ON SELECTION POPUP
ON SHUTDOWN
Command eh en
ON()
Function eh er
ORDER()
OS()
PACK
PAD()
Function ch mp
PADC() | PADL() | PADR()
PARAMETERS
Command mv pe
PARAMETERS()
PAYMENT()
PCOL()
Function en pr
PI()
PLAY MACROS
POP KEY
POP MENU
POP POPUP
POPUP()
PRINTJOB ... ENDPRINTJOB
PRINTSTATUS()
Function lo pr
PRIVATE
PRMBAR()
PRMPAD()
PROCEDURE
PROGRAM()
PROMPT()
PROPER()
PROW()
PRTINFO()
PUBLIC
PUSH KEY
PUSH MENU
PUSH POPUP
PUTFILE()
PV()
QUIT
RAND()
RAT()
RATLINE()
RDLEVEL()
Function nu en
READ
READ MENU
READKEY()
RECALL
RECCOUNT()
RECNO()
RECSIZE()
REGIONAL
REINDEX
RELATION()
RELEASE
Command mv mp wi
RELEASE MODULE
RENAME
REPLACE
REPLACE FROM ARRAY
REPLICATE()
REPORT
RESTORE FROM
RESTORE MACROS
RESTORE SCREEN
RESTORE WINDOW
RESUME
RETRY
RETURN
RGBSCHEME()
Function en nx
RIGHT()
RLOCK()
ROUND()
ROW()
RTOD()
RTRIM()
RUN | !
SAVE MACROS
SAVE SCREEN
SAVE TO
SAVE WINDOW
SCAN
SCATTER
SCHEME()
SCOLS()
SCROLL
SECONDS()
SEEK
SEEK()
SELECT
SELECT()
SELECT - SQL
Command sq db ex
SET
SET ALTERNATE
SET ANSI
SET AUTOSAVE
SET BELL
SET BLINK
SET BLOCKSIZE
SET BORDER
Command mp wi
SET BRSTATUS
SET CARRY
SET CENTURY
Command en dt
SET CLEAR
SET CLOCK
Command en ex
SET COLLATE
SET COLOR Commands
SET COLOR OF
SET COLOR OF SCHEME
SET COLOR SET
SET COLOR TO
SET COMPATIBLE
Command en 26
SET CONFIRM
Command in km
SET CONSOLE
SET CPCOMPILE
SET CPDIALOG
SET CURRENCY
SET CURSOR
SET DATE
Command en in dt
SET DEBUG
SET DECIMALS
SET DEFAULT
SET DELETED
SET DELIMITERS
SET DEVELOPMENT
Command er ex
SET DEVICE
Command fm en in ex
SET DISPLAY
SET DOHISTORY
SET ECHO
SET ESCAPE
SET EXACT
SET EXCLUSIVE
Command mu
SET FIELDS
Command db 26
SET FILTER
SET FIXED
SET FORMAT
Command in 26
SET FULLPATH
SET FUNCTION
Command en km
SET HEADING
SET HELP
SET HELPFILTER
SET HOURS
Command dt en
SET INDEX
SET INTENSITY
SET KEY
SET KEYCOMP
Command km nx
SET LIBRARY
Command pe 26
SET LOCK
SET LOGERRORS
SET MACKEY
SET MARGIN
SET MARK OF
SET MARK TO
SET MEMOWIDTH
SET MESSAGE
SET MOUSE
SET MULTILOCKS
SET NEAR
SET NOCPTRANS
SET NOTIFY
SET ODOMETER
Command in en
SET OPTIMIZE
Command en db
SET ORDER
SET PALETTE
Command en in nx
SET PATH
SET PDSETUP
SET POINT
SET PRINTER
SET PROCEDURE
SET READBORDER
Command in ex nx
SET REFRESH
SET RELATION
SET RELATION OFF
SET REPROCESS
SET RESOURCE
SET SAFETY
SET SCOREBOARD
SET SEPARATOR
SET SHADOWS
Command wi in
SET SKIP
SET SKIP OF
SET SPACE
SET STATUS
SET STATUS BAR
Command en nx
SET STEP
SET STICKY
SET SYSMENU
SET TALK
Command en er
SET TEXTMERGE
Command tm fi pe
SET TEXTMERGE DELIMITERS
SET TOPIC
SET TRBETWEEN
SET TYPEAHEAD
SET UDFPARMS
SET UNIQUE
SET VIEW
SET WINDOW OF MEMO
SET()
SHOW GET
SHOW GETS
SHOW MENU
SHOW OBJECT
SHOW POPUP
SHOW WINDOW
SIGN()
SIN()
SIZE POPUP
SKIP
SKPBAR()
SKPPAD()
SORT
SOUNDEX()
SPACE()
SQL
SQRT()
SROWS()
STORE
STR()
STRTRAN()
STUFF()
SUBSTR()
SUM
SUSPEND
SYSMETRIC()
SYS()
SYS(0) Network machine #/name
SYS(1) Julian system date
SYS(2) Seconds since midnight
SYS(3) Unique file name
SYS(5) DEFAULT drive
SYS(6) PRINTER device
SYS(7) FORMAT file
SYS(9) FoxPro serial number
SYS(10) String from day number
SYS(11) Julian day number
SYS(12) Remaining memory
SYS(13) Printer status
Function pr
SYS(14) Index expression
SYS(15) Character translation
SYS(16) Executing program name
Function er en
SYS(17) Processor in use
SYS(18) Current field/object
Function er in
SYS(20) Transform German text
Function ch dc nx
SYS(21) Master index number
SYS(22) Master tag/index name
SYS(23) EMS memory available
SYS(24) EMS memory limit
SYS(100) CONSOLE setting
SYS(101) DEVICE setting
SYS(102) PRINTER setting
SYS(103) TALK setting
SYS(1001) FoxPro's memory
SYS(1016) User alloc. memory
SYS(1037) Print Setup Dialog
SYS(2000) File wildcard match
SYS(2001) SET command status
SYS(2002) Turn cursor on/off
SYS(2003) Current directory
SYS(2004) FoxPro's directory
SYS(2005) Resource file
SYS(2006) Graphics card
SYS(2007) Checksum
SYS(2008) Cursor shape
SYS(2009) Swap cursor shape
SYS(2010) FILES in CONFIG.SYS
SYS(2011) Lock status
SYS(2012) Memo file blocksize
SYS(2013) System menu name
SYS(2014) Minimum path
SYS(2015) Unique name
SYS(2016) SHOW GETS WINDOW
Function wi
SYS(2017) Show sign-on screen
SYS(2018) Error message
Function er
SYS(2019) Configuration file
SYS(2020) Disk size
SYS(2021) Filtered index expr
SYS(2022) Disk cluster size
SYS(2023) Temporary file drive
TAG()
TAN()
TARGET()
TEXT ... ENDTEXT
TIME()
TOTAL
TRANSFORM()
Function ch dc in
TRIM()
TXTWIDTH()
TYPE
Command fm pr ex
TYPE()
UNLOCK
UPDATE
UPDATED()
Function db in
UPPER()
USE
Command db mu ex
USED()
USER-DEFINED FUNCTIONS (UDFs)
Function lo db in
VAL()
VARREAD()
VERSION()
WAIT
Command mv er pe
WBORDER()
WCHILD()
WCOLS()
WEXIST()
WFONT()
Function ch in nx
WLAST()
WLCOL()
WLROW()
WMAXIMUM()
WMINIMUM()
WONTOP()
WOUTPUT()
WPARENT()
WREAD()
WROWS()
WTITLE()
WVISIBLE()
YEAR()
Function nu dt
ZAP
ZOOM WINDOW
SYSTEM MEMORY VARIABLES
Sysmemvar mv
_ALIGNMENT
Sysmemvar pr
_ASSIST
Sysmemvar 26
_BEAUTIFY
Sysmemvar er
_BOX
_CALCMEM
Sysmemvar da
_CALCVALUE
_CLIPTEXT
Sysmemvar en
_CUROBJ
Sysmemvar in
_DBLCLICK
_DIARYDATE
_DOS
Sysmemvar en nx
_FOXDOC
_FOXGRAPH
_GENGRAPH
_GENMENU
Sysmemvar mp pr
_GENPD
_GENSCRN
_GENXTAB
_INDENT
_LMARGIN
_MAC
_MLINE
Sysmemvar db
_PADVANCE
_PAGENO
_PBPAGE
_PCOLNO
_PCOPIES
_PDRIVER
_PDSETUP
_PECODE
_PEJECT
_PEPAGE
_PLENGTH
_PLINENO
_PLOFFSET
_PPITCH
_PQUALITY
_PRETEXT
Sysmemvar tm
_PSCODE
_PSPACING
_PWAIT
_RMARGIN
_SHELL
_SPELLCHK
Sysmemvar fm nx
_STARTUP
Sysmemvar pe en
_TABS
_TALLY
_TEXT
_THROTTLE
Sysmemvar pe er
_TRANSPORT
Sysmemvar er nx
_UNIX
_WINDOWS
_WRAP
ÍÍÍÍ The FoxPro Interface ÍÍÍÍ
General in di wi me
þ 1-To-Many
Interface di
þ About FoxPro
Interface di me
þ Add File
Interface di me 26
þ Add Screen
þ Add Table/Query
Interface di 26
þ Add/Modify Index
þ Alerts
Interface ge
þ Append
Interface me wi
þ Append From
þ Associated Window
þ Attributes
þ Average
þ Beautification Options
þ Browse
þ Build Option
þ Calculate
þ Calculate Field
þ Calculator
þ Calendar/Diary
þ Catalog Manager
Interface 26
þ Catalog Manager Print
þ Catalog Manager Settings
þ Change
þ Change Index
þ Change Link
þ Change Label
þ Change Query
þ Change Report
þ Change Screen
þ Check Box
þ Choose Field/Variable
þ Client-Server Query Wizard
þ Code Snippet
Interface wi
þ Command
þ Comment
þ Compile
þ Control Menu
Interface me
þ Convert to Static
þ Copy Directory
þ Copy Files
þ Copy To
þ Count
þ Create Expression
þ Create Index
þ Create Label
þ Create Program
þ Create Query
þ Create Report
þ Create Screen
þ Create Table
þ Data Menu
Interface me 26
þ Data Grouping
þ Database Menu
þ Debug
þ Delete
þ Delete Directory
þ Delete Files
þ Detail
þ Do
þ Edit Link
þ Edit Menu
þ Edit Preferences
þ Edit Region
þ Edit Screen Set
þ Environment
þ Execution Throttle
þ Exit
þ Exit Catalog
þ Export Data
þ Expression
þ Expression Builder
þ Field
þ Field Picker
þ File Description
þ File Information
þ File Menu
þ Filer
þ Find
þ Find Files
þ Font
þ Format
þ Format Codes
þ FoxDoc
þ General Options
þ Generate
þ Generate Menu
þ Generate Screen
þ Goto
þ Goto Line
þ Group Info
þ Group/Total Report Wizard
þ Help Contents
þ Help Menu
Interface me wi 26
þ Help Topics
þ Hot Keys
þ Icon File
þ Import Data
þ Index
þ Insert Object
þ Insert Object From File
þ Introductory Screen
þ Key Definition
þ Label
þ Label Wizard
þ Labels in Catalog Manager
þ List
þ Locate
þ Locate File
þ Macro Key Definition
þ Macro Edit
þ Macros
þ Mail Merge Wizard
þ Make Directory
þ Menu Design
þ Menu Options
þ Move Directory
þ Move Files
þ Multi-Column Report Wizard
þ Navigating in the Interface
þ New
þ New Label
þ Object
þ Object Menu
þ Object Order
þ Open
þ Options
þ Order Table
þ Pack
þ Page Footer
þ Page Header
þ Page Layout
þ Page Preview
þ Paste Special
þ Path
þ Picture
þ Popup
þ Print
þ Print Setup
þ Print When
þ Program Menu
þ Programs in Catalog Manager
þ Project
þ Project Information
þ Prompt Options
þ Push Button
þ Puzzle
þ Queries in Catalog Manager
þ Quick Report
þ Quick Screen
þ RQBE
þ RQBE Display Options
þ RQBE Group By
þ RQBE Having
þ RQBE Join Condition
þ RQBE Order By
þ RQBE Select Fields
þ Radio Button
þ Recall
þ Record Menu
þ Rectangle / Line
þ Reindex
þ Remove File
þ Rename Directory
þ Rename Files
þ Replace
þ Report
þ Report Expression
þ Report Layout
þ Report Picture
þ Report Variables
þ Report Wizard
þ Reports in Catalog Manager
þ Restore Macros
þ Revert
þ Round Rectangle
þ Ruler/Grid
þ Run Menu
þ Save As
þ Save Macros
þ Scope
Interface di ge
þ Screen Code
þ Screen Color
þ Screen Design
þ Screen Layout
þ Screen Picture
þ Screen Wizard
þ Screens in Catalog Manager
þ Seek
þ Select Directory
þ Set Index Order
þ Setup
þ Size
þ Sort
þ Sort Files
þ Specify Text
þ Spelling
þ Spelling Options
þ Spinner
þ SQL Query Wizard
þ Stop Recording Macro
þ Sum
þ System Messages
þ Table Structure
þ Table Wizard
þ Tables in Catalog Manager
þ Target Directory
þ Text Editing
þ Text Menu
þ Text
þ Title/Summary
þ Tools Menu
þ Total
þ Trace
þ Transporter
þ Try It
þ Updatable Query Wizard
þ Variable Definition
þ View
þ View Menu
þ Window Menu
þ Window Style
þ Wizards